"""
Copyright (c) 2023 - present SKbioinfo
"""

from apps.API.connect import MysqlConnection
from apps.API.common.db_table_config import *

def get_project_info():
    ### set up MYSQL connection ###
    db_conn=MysqlConnection()
    ### SQL: project_base_info_sql ###
    project_base_info_sql = '''
    SELECT	
        id,
        project_id,
        project_name
    FROM {table_name};
    '''.format(
        table_name = common_tables.project_db["name"]
    )
    project_base_info = db_conn.dic_Query(project_base_info_sql)
    db_conn.close_conn()
    return project_base_info